Tabela DrugInvoice

Definicja tabeli DrugInvoice

Name

DrugInvoice

Code

DrugInvoice

Comment

 


Lista kolumn tabeli DrugInvoice

Name

Code

DrugInvoiceID

DrugInvoiceID

InvoiceStatusID

InvoiceStatusID

InvoiceNo

InvoiceNo

SellerTaxPayerID

SellerTaxPayerID

Deleted

Deleted

ExportStatus

ExportStatus

ErrorFlag

ErrorFlag

ErrorDescription

ErrorDescription

ExportGenerationNo

ExportGenerationNo

InvoiceDate

InvoiceDate

CurrentInvoiceStatusID

CurrentInvoiceStatusID

SellDate

SellDate

Value

Value

ExtDocument

ExtDocument

ContractorName

ContractorName

ContractorAddressID

ContractorAddressID


Kolumna DrugInvoiceID tabeli DrugInvoice

Definicja kolumny DrugInvoiceID tabeli DrugInvoice

Name

DrugInvoiceID

Code

DrugInvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InvoiceStatusID tabeli DrugInvoice

Definicja kolumny InvoiceStatusID tabeli DrugInvoice

Name

InvoiceStatusID

Code

InvoiceStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceNo tabeli DrugInvoice

Definicja kolumny InvoiceNo tabeli DrugInvoice

Name

InvoiceNo

Code

InvoiceNo

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna SellerTaxPayerID tabeli DrugInvoice

Definicja kolumny SellerTaxPayerID tabeli DrugInvoice

Name

SellerTaxPayerID

Code

SellerTaxPayerID

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna Deleted tabeli DrugInvoice

Definicja kolumny Deleted tabeli DrugInvoice

Name

Deleted

Code

Deleted

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ExportStatus tabeli DrugInvoice

Definicja kolumny ExportStatus tabeli DrugInvoice

Name

ExportStatus

Code

ExportStatus

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ErrorFlag tabeli DrugInvoice

Definicja kolumny ErrorFlag tabeli DrugInvoice

Name

ErrorFlag

Code

ErrorFlag

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ErrorDescription tabeli DrugInvoice

Definicja kolumny ErrorDescription tabeli DrugInvoice

Name

ErrorDescription

Code

ErrorDescription

Data Type

VARCHAR2(125)

Mandatory

No

Comment

 


Kolumna ExportGenerationNo tabeli DrugInvoice

Definicja kolumny ExportGenerationNo tabeli DrugInvoice

Name

ExportGenerationNo

Code

ExportGenerationNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceDate tabeli DrugInvoice

Definicja kolumny InvoiceDate tabeli DrugInvoice

Name

InvoiceDate

Code

InvoiceDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CurrentInvoiceStatusID tabeli DrugInvoice

Definicja kolumny CurrentInvoiceStatusID tabeli DrugInvoice

Name

CurrentInvoiceStatusID

Code

CurrentInvoiceStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SellDate tabeli DrugInvoice

Definicja kolumny SellDate tabeli DrugInvoice

Name

SellDate

Code

SellDate

Data Type

DATE

Mandatory

No

Comment

Data sprzedazy


Kolumna Value tabeli DrugInvoice

Definicja kolumny Value tabeli DrugInvoice

Name

Value

Code

Value

Data Type

NUMBER(15,2)

Mandatory

No

Comment

Kwota dokumentu


Kolumna ExtDocument tabeli DrugInvoice

Definicja kolumny ExtDocument tabeli DrugInvoice

Name

ExtDocument

Code

ExtDocument

Data Type

VARCHAR2(66)

Mandatory

No

Comment

Klucz systemu zewnetrznego faktury lekowej


Kolumna ContractorName tabeli DrugInvoice

Definicja kolumny ContractorName tabeli DrugInvoice

Name

ContractorName

Code

ContractorName

Data Type

VARCHAR2(101)

Mandatory

No

Comment

Nazwa dostawcy leków, który wystawil fakture


Kolumna ContractorAddressID tabeli DrugInvoice

Definicja kolumny ContractorAddressID tabeli DrugInvoice

Name

ContractorAddressID

Code

ContractorAddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

Adres dostawcy leków


Lista kluczy tabeli DrugInvoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DrugInvoice

Definicja klucza Identifier_1 tabeli DrugInvoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment